SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbRelUsuarioRol
AS
SELECT dbo.tb_relUsuarioRol.idRol AS id, dbo.tb_relUsuarioRol.idUsuario, dbo.vwrRoles.descripcion
FROM  dbo.tb_relUsuarioRol INNER JOIN
               dbo.vwrRoles ON dbo.tb_relUsuarioRol.idRol = dbo.vwrRoles.id
GO
GRANT SELECT ON  [dbo].[vwbRelUsuarioRol] TO [AdministracionSagenet]
GRANT SELECT ON  [dbo].[vwbRelUsuarioRol] TO [SoloVer]
GO
